#!/bin/bash
echo $(date "+%Y-%m-%d %H:%M:%S")
docker exec postgis /bin/bash -c 'psql -U tjhk -d cyc12 -c "UPDATE location_now SET c_id = g.c_id FROM region g WHERE ST_Within(location_now.location,g.geom) AND location_now.c_id IS NULL"'
